SELECT T.*, J_DT.CODE AS TYPE_CO, J_DT.NAME AS TYPE_NA
FROM FD_DICTIONARY T
JOIN FD_DICTIONARY_TY J_DT ON ( J_DT.ID = T.TYPE_ID )
WHERE J_DT.CODE = :TYPE_CO